topic Read multiple files in a folder and store the id's and get the corresponding family names in QlikView

Read multiple files in a folder and store the id's and get the corresponding family names

Anuhyak1 — Fri, 15 Nov 2024 23:50:11 GMT

I read multiple files in a folder and extract id's of the excels and store in a variable. How to get the family name of corresponding id's. Also, get the matching TID and TName from other table.

1. Filename Sid Sname Tid Tname NEWFILe NewFile

ex: 13_22_pt.csv 13 LC 35 LC 35_22_pt.csv Rename oldfilename with newfilename

Final Output: 13_22_pt replace with 35_22

Re: Read multiple files in a folder and store the id's and get the corresponding family names

avinashelite — Fri, 09 Oct 2020 14:51:45 GMT

Did not get you , could pre pare some sample files and share with us ? so that we could help you on the same

Re: Read multiple files in a folder and store the id's and get the corresponding family names

Anuhyak1 — Fri, 09 Oct 2020 15:50:22 GMT

Hi Avinash,

I have multiple files in a folder - Get the first of the file means 13 and store in a variable , I want to get the fname of the id (ie. Lithium) and the corresponding Lid, Lname (35, Lithium): Attached for your reference .Please help how to write in scripting

I/p file : 13_22_pt.csv 0/p file: 35_22_pt.csv

Re: Read multiple files in a folder and store the id's and get the corresponding family names

Anuhyak1 — Mon, 12 Oct 2020 13:23:32 GMT

Any suggestions and thoughts on the request plz.

Re: Read multiple files in a folder and store the id's and get the corresponding family names

Brett_Bleess — Tue, 27 Oct 2020 13:34:36 GMT

@Anuhyak1 I believe you are going to need to further clarify your use case in order to get further responses on things, as what you have provided is not really enough for folks to be able to offer much help, as I am not really following what it is you wish to do either. Laying out the use case including your inputs and expected outputs with screenshots if possible, would likely be the most helpful. If you have a QVW file, attaching that may be helpful too.

Regards,
Brett