topic Re: retreving desired records from 30k rows file in Workato Pros Discussion Board

retreving desired records from 30k rows file

Laxman — Thu, 22 Jan 2026 15:16:54 GMT

Hello everyone

I have scenario that 30k rows are there in a file want to retrive only the indentifier which belongs to 72411 from the file.
any suggetion on these...?

Re: retreving desired records from 30k rows file

Sathwik_Malli — Fri, 23 Jan 2026 13:45:17 GMT

Hi @Laxman ,

Try loading the file into 'SQL Transformations' and then write a query in that.
Please let me know if this approach worked.

Thank You.

Re: retreving desired records from 30k rows file

Laxman — Fri, 23 Jan 2026 15:02:28 GMT

Hi Satwik
Its ascii content file as its not csv or any other the data should like this
C 01B 11 72411 28331571 EUR00100000052024051420250513 BURLET Jean-Crhistophe 107046000019 3 0000000160900000000000000000000000000000000000043600000000002740000000001370000000000000000000000000000000000000230000000000027400 0000001B M1

Re: retreving desired records from 30k rows file

gary1 — Fri, 23 Jan 2026 18:36:58 GMT

John Dewey once said "A problem well put is half-solved."