topic Generic Load in QlikView

Generic Load

alec1982 — Tue, 28 Aug 2012 13:53:11 GMT

Hi guys,

I've been working on this for over the last two days and I got so many help but I am still not able to complete it.

I have a table that shows data as attached sample.

Is there anyway i can do a Generic load to load data correctly

The unique Key should be raw ID

Raw Id record ID (Values of Custom Field Label) (Values of Custom Field Value)

20932 48421 CV1 CV2 CV3 CV4........ V1..V2..V3..V4.....

26746 48048 CV1 CV2 CV3 CV4.... V1..V2..V3..V4...

26747 48048 CV1 CV2 CV3 CV4.... V1..V2..V3..V4...

And so on.

whiteline — Tue, 28 Aug 2012 14:28:06 GMT

What is exactly your problem ?

The possible solution has been posted.

Another thing to try is not to drop tables in the same loop with joins.

Drop It later in a second loop.

Found it. Your problem as I said was spaces.

Your previous code works perfect, you should just use [] with table name.

FOR i = 1 to FieldValueCount('Tablename')

LET vTable = FieldValue('Tablename', $(i));

LEFT JOIN (result) LOAD * RESIDENT [$(vTable)];

DROP TABLE [$(vTable)];

NEXT i

alec1982 — Tue, 28 Aug 2012 14:57:34 GMT

hi,

thanks for your help.

I don't think the spaces are causing the issue.

Simply this code got me what i need:

original:

LOAD RecordId,

CustomFieldSection,

RowId,

CustomFieldLabel,

CustomFieldValue

FROM [..\data\harborflex\hbdata.xml] (XmlSimple, Table is [PortfolioExportData/tblCustomFieldValue])

Where CustomFieldSection='Office Composition';

temp1:

generic load * resident original;

drop table original;

Thanks,