Hello, I Have two files one file has only Id numbers and second file has table with for example 4 column, and its first column has Id number. So I want to compare the first element of the ID file with the 1st column of the table file's all elements of that column until it find the matches. If compare match then LED will be ON other wise LED will be OFF. Here in attachment I have attached the both file. Please guide me how can I do the same. Thank you very much in advance.

Hi Ankit, so: 1. you want to set an ID that you want to search in the first column of the file. 2. if you find that ID in the file, "forward" message is generated and the data (X, Y) is displayed in the indicators, - the program does not stop its execution, - it finds only the first occurence of the ID in the file 3. if you do not find that ID in the file, "stop" message is generated, - the program does not stop its execution, 4. if the FINAL ID is equal to ID, the program stops its execution, - no message is generated so the program will stop only if the FINAL ID and ID are equal? Will this be a SubVI? Is it not better to use only for loop to search the file for the ID and if the ID is found, "forward" message is generated, led is true, and data (X, Y) is forwarded? if the ID is not found, "stop" message is generated and obviously no data is forwarded. and before all of this check if the ID is equal to FINAL ID, if they are equal, skip the rest if they are not, do search if the ID is found or not?

LabVIEW

How to compare one by one element of one column with other table's first column ??

Solved!

Author

Thank you very much for your reply.

I have put this in while loop because i have one sensor and i have to do mapping using that sensor.

that sensor gives me Id number angle x and y data.

but i have to compare the ID and if Id is match then go forward other wise stop.

as you mension step in your previous answer is exactly what i want.

But the concept is device does not know what is the final id, how many reading it has to do so i want to set that Final Id, when it read the final id and during the measurment when final id is matched then programm will stop.

other wise

continue mapping until the final id is matched or wrong id is detected.

step 1. enter the final id.

step 2. ener the file path where your file is saved with all the data of ID angle X and Y.

step 3. run the program and enter ID, so comparison operation will start and if id match then forward string will generated if not then stop string or programm will be stop.

step 4. ID match then enter new id again comparision and if all id matched entered by user then programm will be continuew until the final id is detected and when final id matched with id enterd by me then program will be stop.

that means two case for stop the programm that 1.. is when final id is matched with current id and 2nd is when false id is detected in this both cases programm should be stop.

hope you will get my point why I want contunes while loop for my operation.

here in attachemnet i have attached vi which you send me in last post but its not working properly can you suggest me that what changes shoul i need to do.

thank you very much for your time and help.