Line Item Categories
Line Item Details
Payment Methods
Initial State
Practice Exercise 4
Use the Payment Methods table to add Transfer Method as a column to "Start 4.1". Combine the "Line Item Details" and "Line Item Categories" information. Finally flag all transactions to unknown vendors that were paid "Direct Deposit".
Associate the appropriate "Transfer Method" with each transaction based on its "Urgency".
Then combine the "Line Item Categories" information with the "Line Item Details" info (the headers in Line Item Details are product SKUs).
Finally, combine both datastreams to flag all orders which were paid to unknown vendors (N/A) and were paid via "Direct Deposit". Mark those transactions with "REVIEW" and all others with null.
Final State
Not Specified
Check
Low
Check
Medium
Direct Deposit
High
Direct Deposit
Critical
Wire Transfer
Start 4.1.yxdb
Start 4.1.yxdb
Line_Item_Categories.yxdb
Line_Item_Categories.yxdb
Line_Item_Details.yxdb
Line_Item_Details.yxdb
Final State - Exercise 4.yxdb
Final State - Exercise 4.yxdb
Urgency
Priority
Transfer Method
FindAny
Append
Line_Item_ID
Last
Line_Item_ID
Warn
Warn
Simple
=
Info_Category
True
fixed
2020-06-03 09:00:06
0
Vendor
2020-06-03 09:00:06
2020-06-03 09:00:06
[Info_Category] = "Vendor"
Value
Name
Name
FindAny
Append
Simple
IsNotNull
Line_Item_ID
True
fixed
2020-06-03 09:06:55
0
2020-06-03 09:06:55
2020-06-03 09:06:55
!IsNull([Line_Item_ID])
Review = IF [Vendor] = "N/A" AND [Transfer Method] = "Direct Deposit" THEN "Revi...
C:\Users\goochri\Documents\Analytics\Alteryx\Getting Started Learning Path\Practice Exercise 4 Solution.xlsx|||Sheet1
False
Create
Practice Exercise 4 Solution.xlsx
Query=Sheet1
Horizontal
Practice Exercise 4 Solution