.xls Transformation

[pamaxeed]

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

01

02

03

etc.

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

Thanks in advance!

Patric

[pamaxeed]

Nobody an idea?

[arniewolff]

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

[danieloberbilli]

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

[marcus_sommer]

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