Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to manage multiple same data file ? Hi

How to manage multiple same data file ?


Hi All

I have sales order raw data file for :-

Company A

Company B

Company C

Company D

My old approach is create 4 similar set of script. And I concatenance all Table into one table. For this I need to use 4 Tab. And need to repeat 4 time for same recode field. Very messy

New approach I want to try is using loop . For this the adv is I only using one Tab. For recode same field I only need do once , very neat.

May I know it there any better approach ?

Paul

2 Replies
MarcoWedel

Hi,

you could use wildcards in your file name as well:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularS...

hope this helps

regards

Marco

paulyeo11
Master
Master
Author

Hi Marco

Thank you very much for your sharing. Can you give me one example pjs .

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>