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
Hi Tabletuner , not yet ... still working on a final solution. I postet this picture only to finalise the problem statement. Within other Topics in here we move on to eventually do NOT USE generic load. As Marcus explains this is critical and we believe we will be able to find different solution. But to answer you question - Problem is not yet solved only several ways are seen. Best Regards Thanks Timo
Hi Timo, in the attachment you will find a general idea of the use of generic load to your problem. After some finetuning in the transformation you might be able to solve it.
thanks TableTuner . I need to talk to our companies IT to import as I am probably not allowed yet. I get a timeout and I am not able to see the LOG file. "The Rest API called Timeout between Services"
Best Regards
Hi Tabletuner - I do still have some issues with this file. Can't import. Even our IT will get the ""The Rest API called Timeout between Services" error. Can you let me know what might be the issue ?
Regards
Hi Timo,
the file was created in QlikView. Maybe you are trying to open it in Sense?
This is true! Please can you supply a Sense version ?
I got it Tabletuner ... we extracted code and moved to Sense ...