Load and update SQL file in dynamic input tool

[WinterBear]

Hello,

I'm trying to use dynamic input tool to

1. load the latest .sql file under one folder.

2. Then update the sql using macro.

I'm not sure if I can use two dynamic input tool one after another to solve this, but I'm stuck at loading the file. I'm not sure what file format should I use will loading the sql file. I read through the discussions on the forum and used csv as the file format. But I got error saying 'Too many fields in record'

My current workflow looks like this

Please let me know if I'm not clear on my question. And thank you in advance for your help!

[FrederikE · Accepted solution]

Hey @WinterBear,

You can load a sql-file with such a config. - Delimiter "\0" means no delimiter used. 

[WinterBear]

That works. Thank you so much!