add same field names data while loading

[Anonymous]

hi folks,

how to add unit1+unit1=unit1 revenue

                 unit2+unit2=unit2 revenue in advance.venue

                 unit3+unit3=unit3 revenue

while loading flat file data into qlikview.

plz find the attached excel file.

thanks in advance

[jagan · Accepted solution]

Hi,

Please check the attached file for solution.

Regards,

Jagan.

[Anonymous]

hi jagan,

thanks for ur valuable time .

can u plz explain logc in script.

[jagan]

Hi Joshi,

This is the script I used in the attached file

Table:

LOAD

    CONCAT(A, '+') AS A,

    B AS B   

RESIDENT Temp

GROUP BY B;

Here I am Grouping the data by column B of table B(which has data already).

The Concat() will concat the values of A grouped by B separated by '+' symbol.

The above is simlar to Sum(Sales) (for example), if you use this it will sum up all the values by B, likewise here it concats all the values of A.

Hope it is clear for you now.

Regards,

Jagan.

[Anonymous]

hi jagan,

thanks for valuable time