Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
brand new Qlik User with a massive project ...
Reinvent a running application using QLIK instead of hardcoded C# . We do have this hardcoded C# exe file which forwards 3 CSV files line by line into a new SQL Master-table. Applying filters deleting empty rows and transpose the data structure. Acctually the transpose function is the major reason we do this line by line.
Now how will I be able to create this master table in Qlik. The attached picture is just a sample of the first part of the original code - creating the Mastertable from filterd Project table. Transposing is not shown yet. But I need to know if it is possible at all.
In Qlik I hardly codes anything yet. BUT in fact what I did so far is not even working out . The where statement is not considered and the table PROJEKTE looks very poor compared to the original CSV there is a lot of data missing.
Dont be confused because of the xls file extension .. it is a CSV format delimiter Tab.
Best regards
Timo
Also the opposite of a crosstable-statement is available, see: The Generic Load - Qlik Community - 1473470
But AFAIK it's quite rare that such a data-structure is useful and beneficial against "normal" structures especially in a final data-model and the UI. I suggest not to try to transfer a SQL scheme and/or any programming logic 1:1 to Qlik else to be open to the native features of Qlik especially the associative data-model.
This is not very clear to me, however, if your goal is to transpose a row of data in multiple rows, I don't think you will be able to do it in a single pass on Qlik neither.
Could you share dummy data how what you have in entry and of what you expect to have in output?
Maybe you can have a look at the crosstable() function. It is used a lot to transpose tables.
Thank you for your answer... attached I uploaded 2 screenshoots. First shows replication of the actual SAP datasource as a CSV extract. Within this you'll find for each Order (WBS) several network actions (oper/Act)
--> e.g. 34, 45, 100,70etc...
Second screenshot shows the "final" transposed datatable / mastertable - the network activities are within one row of the corresponding order.
The source "Order" and "Network Activity" is listed in 2 separet CSV Files / eventually 2 Separete Data Base Tables / SAP Transactions. The linking key is the Order Number (part of the first 11digits of WBS (X)+ the Item (part of last 8digits(Y)) ).
Q/0XXXXXXXXX-00YY-142
Hope you'll be able to follow this explanation. And even more looking forward to find a solution.
Best Regards
Timo
Hi... thank you for this idea. If you check my reply to vincent and follow my description you would tell me again that this crosstable () funktion is suitable for me ?
Where can I study the syntax or have a look on examples ..
Thanks a lot
Regards Timo
Hi again tabletuner... I checked the crosstable function on the net and even this seems to work perferct to transposte columns in to rows , my problem is completly vise versa. I will need to "filter" and transpose ROW - data into columns . I attached a screenshot trying to explane.. for better understanding. Thanks anyway for the crossfunction hint. Best Regards Timo
Here I add the code of the transpose part . Will this be possible during data load or is it eventually possible during sheet creation to skript this?
Also the opposite of a crosstable-statement is available, see: The Generic Load - Qlik Community - 1473470
But AFAIK it's quite rare that such a data-structure is useful and beneficial against "normal" structures especially in a final data-model and the UI. I suggest not to try to transfer a SQL scheme and/or any programming logic 1:1 to Qlik else to be open to the native features of Qlik especially the associative data-model.
to summerice the problem Statement see here :
Timo, you marked the answer of Marcus as solwved. But now you are posting a new post. Is your problem solved or not? If not I will have a look at it.