topic Re: Need Help in QlikView

How to map Header table fields to Data table data??

Nagaraju_KCS — Mon, 08 Feb 2016 07:27:36 GMT

Hi Community,

I have 2 tables one is Headers Table and Data Table.

Table1:

CategoryID

CategoryName

Product

Cost

Table2:

100, Nokia, N70, 12000

101, Samsung, Sam1, 10500

102, LG, LG1, 2500

103, Apple, Apple1, 25000

How to map these tables??

My Output should be like..

CategoryID, CategoryName, Product, Cost

100, Nokia, N70, 12000

101, Samsung, Sam1, 10500

102, LG, LG1, 2500

103, Apple, Apple1, 25000

Thanks in Advance...

Re: Need Help

jonathandienst — Mon, 08 Feb 2016 07:54:50 GMT

I assume you are loading from a text file, otherwise you would get the headers from the database field names:

Data:

LOAD *

FROM mysource.csv

(txt, no labels, delimiter is ',');

MapNames:

Mapping LOAD

'@' & RowNo() As Field,

HeaderName

;

LOAD @1 As HeaderName

FROM headerlnames.txt

(txt, no labels, delimiter is ',');

Rename Fields using MapNames;

Adapt the loads to your specific environment

Re: Need Help

petter — Mon, 08 Feb 2016 08:07:54 GMT

Please use a more descriptive title for your questions than "Need help". It will help everyone to better spot if it is a request they want to read. If you haven't already looked at the guidelines on how to post on this forum please have a look or please review the good advice you find there.

kind regards

Petter Skjolden

Re: How to map Header table fields to Data table data??

Nagaraju_KCS — Mon, 08 Feb 2016 08:31:10 GMT

Thanks for Advise .....

Re: Need Help

Nagaraju_KCS — Mon, 08 Feb 2016 17:56:33 GMT

HI Jonathan,

If i am use 2 flat files, its working fine, but here

Headers coming from Flat file(CSV)

Data coming from XL file..

Flat file taking like(@1, @2.... so on)

If we have flat files..

Mapping LOAD

'@' & RowNo() As Field,

HeaderName

Suppose if i have Excel file like(A, B, C...)

I am using Chr(65) instead of '@'

But how to increase the value for ASCII code....

PFA..

Re: How to map Header table fields to Data table data??

jonathandienst — Tue, 09 Feb 2016 07:14:34 GMT

MapNames:

Mapping LOAD

Chr(Ord('A') + RowNo() - 1) As Field,

HeaderName

;

LOAD @1 As HeaderName

FROM headerlnames.txt

(txt, no labels, delimiter is ',');