This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It is kind of difficult to describe what I am trying to accomplish, but I will give it my best.. I want to be able to upload input files with a variable numbers of fields and have my formula tool update to include additional columns.
I want the formula tool in my workflow to be able to dynamically adjust based off the input file that is uploaded. Due to the nature of what I am trying to accomplish with this workflow, the input file will have a variable number of fields that I need to perform a calculation on. In the attached example, my input file has three fields that I am using for a calculation. However, if my input file has 5 fields, I want my formula tool to perform the calculation on the two additional fields.
Additionally, all the field names are likely to change. I would like my join tool to also dynamically update so that it will select the correct field names and number of fields.
I have attached a sample workflow below. If anybody can help me I would greatly appreciate it.
I'm hoping you can add some clarification for me so that I can make sure I'm understanding your goals.
when you refer to 3 vs 5 columns and the column names, are you referring to the number of cross tabs that have to happen (currently Store Count, UPSPW, DPSPW), or the number of distinct "Item Group" categories that we might be evaluating?
No, there will always be only 3 cross tabs. Within each cross tab, there are 3 categories: Drinks, Food, and Other, If I upload a different input that has additional categories (like clothes or hardware) I want the formula tool to include those fields and perform the calculation (contribution).