I was wondering if it's possible to create an SFMC data extension by way of uploading a .csv file? I have one now with 60 fields which is likely to grow as I continue testing and would very much like the option to have SFMC simply create a data extension with the associated fields, rather than having to create them manually. However, I'm not seeing this option anywhere in the data extension creation dialog.
[SalesForce] Create SFMC data extension from CSV file
Related Solutions
You are performing too many lookup queries. Please try the following code
SET @rows = LookupRows("Pull-Field-Test","Date", @today)
IF RowCount(@rows) > 0 THEN
SET @row = Row(@rows,1)
SET @p1 = Field(@row,"Product-1")
SET @p2 = Field(@row,"Product-2")
SET @p3 = Field(@row,"Product-3")
SET @p4 = Field(@row,"Product-4")
SET @p5 = Field(@row,"Product-5")
ENDIF
Note I have not tested this code, please refer to the LookupRows() AMPScript documentation.
try like this see this image you get some idea
Best Answer
There's nothing built-in the platform to do something like that.
There's also nothing stopping you from writing something (in SFMC or not) with the SFMC Web Services to do it.
I use a combination of Excel and LINQPad script (using our own version of the SFMC SDK) to create Data Extensions.