Dynamic Select to Start Importing Columns with Specific Name

Shanlim

Hi, 

I was trying to build a workflow in my macro that can helps to pull the info from different listing from different countries. I would also like to make it as dynamic as possible as it will work for different type of listing. I had identified that I only want to start importing the column that has a code started with "P". However, I had facing the problem as the number of columns before the columns I need is always different. I had tried to look at the dynamic select tool, but not really sure how it works. 

Is there any kind soul that can advice me on this?

Thanks a lot in advance!

AngelosPachis

Hi @Shanlim ,

When you say you only want to keep columns that have a code starting with "P", is that P the first letter in that column header?

In the dynamic select tool, you have two options, the first being to keep only the columns of a certain data type (Byte, String, V_String and so on) and the second is to keep only the columns that fulfill a certain condition, which can be via a formula.

In your instance, if the columns you want to keep start with a "P", then you can define a formula that says:

StartsWith([Name], "P")

which would check if the field name starts with "P" and if it does it will keep that column. An alternative would be:

Left([Name], 1)="P"

which would only check if the first character in your field names from the left hand side is a "P".

I've mocked up an example for you and I have created those 3 fields where only two start with a P and only the first one contains a code

 If you use any of the above formulas, the dynamic select tool would keep the first field (which is a code) and the third field, which also starts with a P but it does not contain code information.

So that means that the dynamic select partially works, but still not perfect because Parameter_4 field which in  my example is not a code is still in my dataset. You have to refine this further, based on the column headers of your dataset, maybe RegEx might help as well.

Can you provide an example of the codes in the column headers and maybe that can help us identify a pattern?

I'm also sending attached a workflow from Alteryx examples on how to use the dynamic select tool.

Hope that helps,

Angelos

Dynamic_Select.yxmd