Possible to concatenate two column in Bex Query designer or to count all rows including duplicated row

[Former Member]

Hello everyone,

Kindly help me to concatenate two columns in Bex Query designer. like

City     store     Article     qty1     qty2     qty3

del          101     1211     1           1          0

ban        1002     154     12          10        1

bang2     120        140     20          15        22

del          101     1211     1           1          0

ban        1002     154     12          10        1

bang2     120        140     20          15        22

del          101     1211     1           1          0

ban        1002     154     12          10        1

bang2     120        140     20          15        22

here number of rows are 9 here del ban and bang2 are repeated again and again.

as i have set the formula and in ref. characteristics set store. but got uniqe count only 3 and want total number of lines i.e 9.

can any one help me.

Regards,

Shiv

[yasemin_kilinc]

Hi Shiv,

This kind of data is not possible in a dataprovider. If you try to load this data (9 records) to an infocube it will directly you will end up with 3 records added to the infocube. You should at least have another characteristic (which will behave as a primary key) to discriminate between rows. If you already have that characteristic in your infoprovider, then you can create a formula using this characteristic as reference.

Hope it helps.

Regards

Yasemin...

[Loed]

Hi,

Why do you want your report to appear on the layout above? Are you sure you can show the LAYOUT of the report you have posted? They should be aggregated in the result of your query..You can only have a three (3) columns on your report above, right? Or if you were able to achieve it, what did you do?

Regards,

Loed