Thank you @LakshmiPravallika   for your response.is there any other way like to delete a field/column directly from list if it's empty?

@david--garcia I have placed List Update activity after JS activity to create the lists with the fields/columns which are not empty. In above code since we are trying to remove column with same command only after checking the counter I think it would throw same error again. Thanks.

@ParthaSarathy I need to unselect the column in case it is empty from an incoming file because some time that column contains values and I have to push it to list. Could you please suggest the approach for the same.

Thank you @david--garcia for your quick response. I tried this approach in JS activity. JS activity get executed and the next activity which is connected to JS activity throws an error. PGS-220000 PostgreSQL error: ERROR: column "spid" does not exist LINE 1: ...sPId) SELECT iLineNum,sFirstName,sLast...

Hi everyone,I'm importing data from a file into campaign list. I'm collecting a file from SFTP using file collector activity, after that I used Data loading (file) activity in workflow. I want to remove a column if it is empty and pass the remaining fields to next activity. Is it possible to remove ...

Hi @Parvesh_Parmar it's a recurring process. once I store the data in list(from file or other sources) if a particular column is empty then in that case I want to delete the field.e.g.I have 3 filesfile1: column A, column B, column Cfile2: column A, column B, column Cfile3: column A, column B, colum...

@akshaaga I tried both JS & SQL approach, getting error. Error with SQL: PGS-220000 PostgreSQL error: ERROR: relation "LISTNAME" does not exist . Error with JS:XTK-170031 Key value 'LISTNAME' is incompatible on element 'schema' for schema 'Entities schemas (xtk:schema)' please let me know what went ...

Hi, I want to delete one of the field of list using JS activity or SQL Code activity through workflow, is it possible? If so, how to do it. Thanks

Hi All, Is there any way to read parquet file data in Adobe campaign classic & load it into list or directly into schema? Appreciate any helpful resources/pointer on this. Thanks

Noted. Thank you @Denis_Bozonnet