09-01-2020 03:27 PM - edited 07-25-2022 09:42 AM
Hi Katrina,
Thanks for sharing this, may I ask if the custom field values will be overwritten with every reload (referencing the "Remove Pre-Existing Data for this Load Code" option).
On a separate scenario, if we only changed the Data Classification field, will the results for Data Steward or Text be wiped as well?
Thank you!
Hi @cy_zhang
Basically if you initially send the large dataset, containing multiple fields, and need to change just one, it woud be ideal to use same file for updating just one field in order to not loose other fields values from previous run. Or you can use the otther approach and send only one custom fields (for Example Data Classification) in one dataset and for the other use the other LOAD_CODE.
Since 2020.3 you can use also Connect API which would may be ideal for your use case. Its slightly mentioned here: https://community.alteryx.com/t5/Alteryx-Connect-Discussions/Dynamically-Load-Tags-for-Database-Tabl... and also in release notes. https://help.alteryx.com/release-notes/connect/connect-20203-release-notes
Hope it help.
Petr Havel
Hey @KaterinaR I only see the xlsx export added as an attachment to your post. I don't see the workflow attached. Would you be able to share that?
Best,
Sean
@sglynn14
Which case is this for? I tried to republish this article with the workflow attached, but for the moment, just tell me the case number and I'll get it sent to you.
Hey @lepome I don't have a case number open for this. I was just exploring the capabilities of custom fields and came across this post. Would you like to take down my email and send it to me that way?
@sglynn14
We much prefer to have all customers holding paid licenses open cases through the Case Portal. It allows us to track their issues, and it prevents situations where customer requests might otherwise slip through cracks if any one Support Engineer is out of office or busy with something else.
For users who have unpaid licenses (Alteryx for Good or Trial) their primary resource is the Community, and I am flagging the article so that it will be addressed as soon as we can get to it. I don't have a time frame of when that will be, however.