Filter and Highlight records

[Vandhana_C]

Hi all,

I have a requirement to highlight the Request ID and names of employees who have not touched a request for more than 2 days excluding weekends.

Thanks in advance

[binuacs]

@Vandhana_C Can you provide a sample input file and expected output for better understanding of your use-case?

[Raj]

@Vandhana_C 
please provide sample input data
will be in better position to help.

[OTrieger]

@Vandhana_C 
No need to share files as we are not intended to create the WF for you, however if you will share some snippets and elaborate a bit on it we can guide you how to get it solve.

Bear in mind that we do not see what you see. You wrote a generic sentence, an equivalent answer to your query will be, "You will need to use different Alteryx tools to get it solved!"

[Vandhana_C]

Hello @OTrieger , @Raj , @binuacs,

 I have attached the snapshots for how the data looks like in both the FIle A and File B below:

File A:

Key Points :
1. Considering all columns have blanks.
2. Value column is either just numbers like 01, 09 or just alphabets like DAY and NY or alphanumeric like 2B and 3N6.
3. Name Column is just alphabets with underscore and hyphen and some accent characters.
4. Description column as words seperated ny underscore.
5. EValue column could be just numbers or alphabets both ranging from 2-3 length long.

6. The ISO2_CountryCode column having 2 word length alphabets.

7. Observation column is something that has to be created using the formula tool where we compare the "ISO2_CountryCode" column from File A with "Country" column in file B. If there is a match we update the observation column as Available in FIle B. Evalue is "NY" and Region Name is "New York".  Evalue should be picked from "region" column and Region Name should be picked for the corresponding record from "Region Description" column from file B. If there is no match then we update the observation column as Missing in FIle B.

File B:

Key Points :

1. Only the Region and Region Description have blanks.
2. Country can range from 2-3 word length.

3. Region can have combination of alphanumeric or just alphabets or just number values.

4. Region description are just alphabets (string) with special characters such as hyphen, underscore, brackets and accent characters.

Hope this is clear.

Thanks

 

[OTrieger]

@Vandhana_C 
Thanks, how the data that you shared with us is relating to you initial request?
"I have a requirement to highlight the Request ID and names of employees who have not touched a request for more than 2 days excluding weekends."

I do not see any dates in the data. Are we still talking about the same query?

[Vandhana_C]

Sorry my bad. Please ignore.
I need a solution for the above for which I have started a new topic but I described it under a wrong topic.