topic Re: add same field names data while loading in QlikView

add same field names data while loading

Anonymous — Wed, 07 Mar 2012 09:35:10 GMT

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

add same field names data while loading

CELAMBARASAN — Wed, 07 Mar 2012 09:45:56 GMT

Hi,

Try with this

LOAD bu,

Sum(revenue) as revenue

FROM

DataSource\commu.bu.xlsx

(ooxml, embedded labels, table is Sheet1) Group by bu;

Hope it helps

Celambarasan

Re: add same field names data while loading

Anonymous — Wed, 07 Mar 2012 09:55:49 GMT

hi thanks for quick responce.

in real data

i need to add ap+mh=unit1

del+no=unit2

like this

Re: add same field names data while loading

CELAMBARASAN — Wed, 07 Mar 2012 09:59:08 GMT

Hi,

Could you tell me brief about the full structure of the table?its easy to me understand and solve.

Celambarasan

Re: add same field names data while loading

Anonymous — Wed, 07 Mar 2012 10:09:43 GMT

hi,

plz find the attached qvw.

Thanks In Advance

Re: add same field names data while loading

CELAMBARASAN — Wed, 07 Mar 2012 11:02:07 GMT

Hi,

I'm using personal edition i cann't open your file.Can you tell me about a structure itself?

Celambarasan

Re: add same field names data while loading

Anonymous — Wed, 07 Mar 2012 11:27:15 GMT

plz find excel sheet

Re: add same field names data while loading

jagan — Wed, 07 Mar 2012 11:43:30 GMT

Hi,

Please check the Excel file and let me know, this is what you require.

Regards,

Jagan.

Re: add same field names data while loading

jagan — Wed, 07 Mar 2012 11:44:23 GMT

Hi,

Please check the Excel file and let me know, this is what you require.

Regards,

Jagan.

Re: add same field names data while loading

Anonymous — Wed, 07 Mar 2012 13:39:24 GMT

hi jagan,

plz find the attached Excel file

Thanks For ur quick responce

Re: add same field names data while loading

jagan — Wed, 07 Mar 2012 13:52:56 GMT

Hi,

Please check the attached file for solution.

Regards,

Jagan.

Re: add same field names data while loading

Anonymous — Thu, 08 Mar 2012 07:18:09 GMT

hi jagan,

thanks for ur valuable time .

can u plz explain logc in script.

add same field names data while loading

jagan — Thu, 08 Mar 2012 07:29:41 GMT

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.

Re: add same field names data while loading

Anonymous — Thu, 08 Mar 2012 13:53:31 GMT

hi jagan,

thanks for valuable time