Test if column is empty after loading the data? | Community
Skip to main content
G
god_prophet
Level 6
October 14, 2023
Solved

Test if column is empty after loading the data?

  • October 14, 2023
  • 1 reply
  • 809 views

Hi, I've an importer that loads a CSV in order to fill  a table (schema). 

We're currently using a test activity to test if there is full data on all columns, but how to do the same of only 1 or n columns?

Our current test activity content: 

vars.recCount > 0

 
how to do test : if "emailcomercial" is empty or celularcomercial is empty end the workflow?


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @god_prophet ,

After data loading activity, connect it with a split activity.

In split activity General tab, select 'Use the additional data only' radio button and select 'generate complement' checkbox. 

In Subset tab, add a filtering condition as emailcomercial is empty or celularcomercial is empty. 

Now connect this emailcomercial celularcomercial Transition to End activity and 'Generate complement' transition to Update data activity to load data into your schema.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
October 14, 2023

Hi @god_prophet ,

After data loading activity, connect it with a split activity.

In split activity General tab, select 'Use the additional data only' radio button and select 'generate complement' checkbox. 

In Subset tab, add a filtering condition as emailcomercial is empty or celularcomercial is empty. 

Now connect this emailcomercial celularcomercial Transition to End activity and 'Generate complement' transition to Update data activity to load data into your schema.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    G
    god_prophetAuthor
    Level 6
    October 14, 2023

    So, this would exclude all the emailcomercial or celularcomercial empty rows, allowing only to pass the rows with emailcomercial or celularcomercial not empty. 

    Therefore, if all values in emailcomercial or celularcomercial are empty, the workflow would end?

    I just want to make sure that if emailcomercial is empty but celularcomercial is not empty, process still needs to end. Or the other way around also. If any or both of these columns is empty , workflow must stop.  

    Thank you.

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    October 14, 2023

    @god_prophet , yes.

    In your subset filtering condition, you need to give the condition as below

     

    @emailcomercial is empty

    OR

    @celularcomercial is empty

     

    So, if your record satisfy in any one of the above condition or in both, that record will be in the output of this subset transition, and it will be connected to End activity.

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Terms & ConditionsAccessibility statement

      Loading footer...