topic Re: Load Field Name As Value in QlikView

Load Field Name As Value

scjoel02 — Mon, 06 Jun 2016 13:59:16 GMT

Greetings Qlik Community!

I have a series of .xml files that store the actual key value as the field name.

I need to load all files, assigning the FieldName as the value stored inside a new field.

It's my understanding that you can't use the FieldName function on a data ingestion. It has to be already preloaded into memory, in order to specify the table name.

Using CrossTable requires inserting the field name to assign as the new field, and that field name is different in every xml file.

The files are structured like the following:

File1:

Field 1, Field 2, Key_ABC123

Red, Apple, 0

File2;

Field 1, Field 2, Key_DEF456

Yellow, Banana, 0

I need to combine these files (with a Load *, because there are way too many to load and concatenate them manually), and assign the Key Field Name as the actual value stored inside of a new key field.

Like this:

Field 1, Field 2, Key

Red, Apple, ABC123

Yellow, Banana, DEF456

Perhaps with a loop?

Any suggestions greatly appreciated.

Thanks!

Re: Load Field Name As Value

sunny_talwar — Mon, 06 Jun 2016 14:36:32 GMT

You can always use LOAD * to avoid entering different field names.

CrossTable(....)

LOAD *

FROM Source.....

Re: Load Field Name As Value

scjoel02 — Mon, 06 Jun 2016 14:39:36 GMT

Hi Sunny.

You can't Load * from an XML. I could potentially store everything into a QVD, or resident load and then crosstable, but how could I Crosstable multiple field names into one?

Thanks.

Re: Load Field Name As Value

sunny_talwar — Mon, 06 Jun 2016 15:00:02 GMT

Oh really, XML don't allow for *? I have never loaded from one, so I didn't know that.