Inut Array to be Manipulated as Output Array

[gowthameie]

Hi Users,

i need some reply from your end.

i want to manipulate Input Columnbox as Output column box

Here i am listing possible conditions for your reference

Conditions:
1)if Same Channel Repeated 'n' times, Last (recent ) result should be replaced with existing same channel result
2)Sort the manipulated array .

For details see the attached image

pls share possible ways to get above requirements

thanks in advance

[Gregory]

Hi gowthameie, please give it a try and share your code (.vi) and where you are getting stuck.

[crossrulz]

I would use a Map to store the rows (array of strings) and use the channel as the key.  Use Insert Into Map to add/replace the values.  Then you can use a FOR loop and an Unbundle By Name to index out your updated rows.  This will even do the sorting for you.

[altenbach]

I am not sure what a "column box" is, but from your picture you are probably talking about tables.

Tables are basically 2D array of strings and contain whatever they get from the wire or user. Typically tables are not useful as controls, because they require significant sanity checks on user inputs (numeric? String? multiline?, etc.)

Are these controls or indicators? Where does the data actually come from? Where will it be used later?

Do you want to process the data currently in the "input" to get the result shown in "output"? Do you want to rewrite the input to look like the output?

Please attach your VI and be very specific! Thanks!

[gowthameie]

Assume i am testing ADC Channel.
i am getting data's. based on the criteria result status (Pass/Fail)is updating.
Few ADC channel result is Fail, I want to repeat the test on the particular channel.
whether the Result Status PASS/FAIL, Recent Data and result status of particular channel to be replaced.
Input Array Size is (7 X 3), after checking, manipulating Output Array Size would be is (4X3)

till i couldnt get solution, pls do the needful

I tried with following method.
Deleting Last row and taking 1st element (Channel no) and comparing any of input array has same channel result.
if yes, replacing that row with deleted row.
similarly i want to check any channel result is repeating. if so, do the same as mentioned above.

I attached VI snipet for your reference

[gowthameie · Accepted solution]

I AM ATTACHING SOLUTION FOR THIS THREAD

[Frozen · Accepted solution]

Couple alternatives (as crossrulz suggested)

Mostly so I can get some experience using maps 🤓