Icon

Onsite and Online Transactions

Onsite and Online Transactions
Challenge 13: Onsite and Online TransactionsIn this challenge, you are asked to extract digits fromthe transactions (which are related to the boughtproducts) given the following guidelines: (1) if the onsitetransaction starts with “L”, then take its first 12 digits;otherwise, take its first 6 digits; and (2) if the onsitetransaction has a missing value, then take the stringfrom the online transaction. create a tableextract only numbersrulessubstring 6substring 12filter columns Table Creator String Manipulation Rule Engine String Manipulation String Manipulation Column Filter Challenge 13: Onsite and Online TransactionsIn this challenge, you are asked to extract digits fromthe transactions (which are related to the boughtproducts) given the following guidelines: (1) if the onsitetransaction starts with “L”, then take its first 12 digits;otherwise, take its first 6 digits; and (2) if the onsitetransaction has a missing value, then take the stringfrom the online transaction. create a tableextract only numbersrulessubstring 6substring 12filter columns Table Creator String Manipulation Rule Engine String Manipulation String Manipulation Column Filter

Nodes

Extensions

Links