Load 1,00,000+ records in Appian in seconds || CSV load in Appian Database || Low Code Bug

[@huynhminh4207]

Thank you! One question. How can I query data from this csv file after importing data to database? I have a datetime column and I need to query the minimum date and save into a variable? The datetime in csv file is not in format in required format for this plugin. Please help me

[@chandrasekhar2796]

Thank you

[@duorenmi]

thank you! if needs a repeated process to load CSV to database, how to remove old uploaded data before to upload the new data?

[@lowcodebug]

Truncate the table by executing query smart service

[@user-yz9kk4ih2k]

Hi, I have a requirement to load csv to database but before loading into database I need to perform security check like checksum of a number cloumn in the csv file. How can perform this.

[@lowcodebug]

We can perform check after we load data into database or save into process variables

[@user-yz9kk4ih2k]

Hi, one last question pls. Is there any function to cast from text to floating point conversion.

[@lowcodebug]

Use cast function and if confused about type number of floating point use typeof() function

[@arundhatipanigrahi1004]

Can Appian hold more than 20lakh records?

[@lowcodebug]

Yes it can hold 60Lakhs Records

[@arundhatipanigrahi1004]

@@lowcodebug Thank you

[@dushyantsalgotra9124]

Can you please tell how to use sFTP plugin to send csv file?

[@lowcodebug]

Send file by sftp?

[@dushyantsalgotra9124]

​@@lowcodebug yes

[@lowcodebug]

We just to to configure the details like private key , host details and credentials 3 party, and use the smart service send File by SFTP and then we are good