Generate Multiple sql Files With csv inputs

vkomarag

That's Awesome !! This is my first post in this forum and I literally felt stranded. Thanks for saving me. I will try this and let you know if it is working fine.

vkomarag

Can I do it using data frames rather than hardcoding

**Yoriz** · Aug-20-2021, 02:39 PM

Of course, I just hardcoded it so I didn't need the data frame.

vkomarag · Aug-20-2021, 07:03 PM

(Aug-20-2021, 02:39 PM)Yoriz Wrote: Of course, I just hardcoded it so I didn't need the data frame.

Quote:How can I apply the below lines to data frame?

appropriate_name = ".".join((row["DB"], row["SCH"], row["TAB"]))

columns = ",\n".join(row["COLS"].split(","))

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	python convert multiple files to multiple lists	MCL169	6	1,557	Nov-25-2023, 05:31 AM Last Post: Iqratech
	Multiple variable inputs when only one is called for	ChrisDall	2	491	Oct-20-2023, 07:43 PM Last Post: deanhystad
	splitting file into multiple files by searching for string	AlphaInc	2	901	Jul-01-2023, 10:35 PM Last Post: Pedroski55
	Merging multiple csv files with same X,Y,Z in each	Auz_Pete	3	1,173	Feb-21-2023, 04:21 AM Last Post: Auz_Pete
	unittest generates multiple files for each of my test case, how do I change to 1 file	zsousa	0	968	Feb-15-2023, 05:34 PM Last Post: zsousa
	Find duplicate files in multiple directories	Pavel_47	9	3,117	Dec-27-2022, 04:47 PM Last Post: deanhystad
	Extract parts of multiple log-files and put it in a dataframe	hasiro	4	2,094	Apr-27-2022, 12:44 PM Last Post: hasiro
	Search multiple CSV files for a string or strings	cubangt	7	8,050	Feb-23-2022, 12:53 AM Last Post: Pedroski55
	Rename part of filename in multiple files	atomxkai	7	7,365	Feb-18-2022, 10:03 PM Last Post: atomxkai
	Process multiple pdf files	Spartan314	1	1,321	Oct-27-2021, 10:46 PM Last Post: Larz60+

Generate Multiple sql Files With csv inputs

User Panel Messages

Announcements