topic Re: .xls Transformation in QlikView

.xls Transformation

pamaxeed — Thu, 04 Sep 2014 12:00:03 GMT

Hi,

i have an .xls file which is dynamically created by our custuomer system.

Attached u have an example extract.

How I can transform the structure of the file, in the way that i have a kind of flat file.

It is about a workflow system, the records hast a dynamic structure:

I have a projectid, a processId (project_run_id) and all the status fields which are created dynamically (like the whole story of a process of the workflow is shown in one record).

How i can tranform it that i will have a flat file structure with fixed field number, e.g.:

Status

etc.

The transformation would explode the number of records for each process.

Thanks in advance!

Patric

Re: .xls Transformation

pamaxeed — Thu, 04 Sep 2014 19:15:48 GMT

Nobody an idea?

Re: .xls Transformation

arniewolff — Wed, 10 Sep 2014 23:52:05 GMT

What if you import the Table File using the File Wizard and select Enable Transformation Step, then select the Rotate tab and click the Transpose button? That should import the file transformed how you want it.

Arnie

Re: .xls Transformation

danieloberbilli — Thu, 11 Sep 2014 01:59:15 GMT

Could you give an example according to your xls-data how the structure should look like and for what reason you would like it like that...maybe there is another way of dealing with it without changing the structure

Re: .xls Transformation

marcus_sommer — Thu, 11 Sep 2014 07:45:24 GMT

What do you mean with "fields which are created dynamically"? The amount and the order from the fields could be different? If yes you could load all files with a forced concatenate into one table then you could read only the fieldnames from this table to make a alphanumeric sorted table and creates with this table a dynamically load-statement which you then stored as utf8-flatfile.

For use in qlikview I think to load these files in a crosstable-load to create a data-stream would be fit better for the most needs.

- Marcus