Hi team. I have 5 columns with numeric values..... I want to give user values in those 5 columns..... Here if I want to give value for one column the remaining columns should have the values that is coming from the input data. Please advise
Hello - This sounds like you need your users to provide their input value. You can achieve this through App. Holding in Alteryx or could also have the user being in a spreadsheet as their reference/input value. How does that sound for a possible solution. There are many ways this can be achieved, just need to understand from you how interactive and sophisticated you want to make this workflow.
Hi,@Inactive User
At first, maybe you can give a data form table both input and output.
Sure, I will come up with the data. Thank you so much.
Hi team here is the data. In this data, I have 5 columns.... If I want to give value for one column the remaining columns should remain same with the original values. Please adise
@Inactive User are you looking for something like below, i only added two numeric drop down
Yes @binu_acs but if I change the 1st column then the 2nd column data should be the orignal one. I dont want to change the 2nd column value.
@Inactive User If you give the numeric dropdown for each fields then the connect fields values will get affect, if you don't want to change any other fields then you have to reduce your input option. In this scenario if you don't want the second column values to change you need to remove the dropdown tool which is connected to that tool.
I mean lets say I have A, B, C, D columns ,,, formula segregated columns are E and F ......So if I change any value in ABCD column then E and F columns will get effect that is absolutely fine. so here If
A has 4
B has 5
C has 6
D has 7
I just want to give user value only to column A .
WHile giving user value to A, the remaing BCD column values shouldnt change
@Inactive User question in real scnario how many options you are going to give to the user to enter the value? I mean to say there will be only one option for the user to enter the value like above (only for column A) or can be either A or B or C or D?
user want to give values for ABCD columns but if user is giving value to A then BCD values should be original data. If user want to give values for AB then CD should be original data.
user want to change all 4 columns but not at a time. If user give value to column A then remaining columns BCD should be original data.If user give value to column AB then remaining columns CD should be original data.If user give value to column ABC then remaining columns D should be original data.Or user want to give value to D then remaining ABC should be orignial data
here is the file.
@binu_acs @flying008 please help