01-22-2019 03:27 AM
@altenbach wrote:
Use index array with one of the indices disconnected. Resize for two outputs.
(depending on which index is disconnected, you either get a row or a column, so just try it)
Could you please help me in this, i want to store data from xls file into array. but data should be display in column wise if string matched. Currently it store data in row wise.
01-22-2019 03:52 AM - edited 01-22-2019 04:01 AM
Hi sam,
please stop posting the same questions in several threads. (Posting the same attachments isn't needed as well…)
One more suggetion:
Use different filenames for your attachments when they don't show the same content/image!
We usually only download to one "download" folder and downloading the same filename again and again makes the browser change the filenames to something like "filename (0)". Because of that we might look at the wrong image when the filename changed unexpectedly…
Btw.:
Attaching images of code instead of the code itself doesn't make a lot of sense…
(And use AutoCleanup before you upload your VI!)
01-22-2019 11:27 PM
You can use "Transpose 2D Array" function to convert row data to column data.
And just like GerdW told before, please stop making several posts for the same question.
Especially for the topic you uploaded, You can find more than 10 similar posts with a minimum effort by simply searching.
01-22-2019 11:50 PM
@jaylee2113 작성:
You can use "Transpose 2D Array" function to convert row data to column data.
And just like GerdW told before, please stop making several posts for the same question.
Especially for the topic you uploaded, You can find more than 10 similar posts with a minimum effort by simply searching.
Hi thanks for your response, but i dont want to covert row data into column. Actually i want to get selected column. I dont know how we select and which function we use to select selective column. Currently it work on selective row which i entered for searching xls file. Thanks
And i understood and i already apologize for my mistake. Thanks
01-23-2019 01:49 AM
Hi sam,
but data should be display in column wise if string matched. Currently it store data in row wise.
Then you should transpose your "dataArray" before displaying it in the indicator…
i dont want to covert row data into column.
But you asked the opposite before!
Actually i want to get selected column.
Where do you want to get "selected column"? Selected by what?
Please provide more information:
01-23-2019 02:21 AM
@GerdW wrote:
Hi sam,
but data should be display in column wise if string matched. Currently it store data in row wise.
Then you should transpose your "dataArray" before displaying it in the indicator…
i dont want to covert row data into column.
But you asked the opposite before!
Actually i want to get selected column.
Where do you want to get "selected column"? Selected by what?
Please provide more information:
- your VI instead of just images of your VI
- example input data
- expected output result
Hi thanks for replying, here is my VI file.
i want to select data from xls file for example in xls file data is display like this,
A B C D E F
1 3 4 5 7 8
3 4.6 5 6.6 7 4.5
.........................................
So i want first search D column instead of D row, currently it search row where D is present. If you have any question please ask me. Thanks
01-23-2019 02:42 AM - edited 01-23-2019 02:44 AM
Hi sam,
why does it take so long before you are able to provide that basic information?
Anyway:
So i want first search D column instead of D row, currently it search row where D is present.
Simple:
Like this:
This shows the basic principle, but does not include any error checking (like for "not found" conditions)…
Btw. didn't I suggest to use AutoCleanup before uploading your VI?
01-23-2019 03:00 AM
@GerdW wrote:
Hi sam,
why does it take so long before you are able to provide that basic information?
Anyway:
So i want first search D column instead of D row, currently it search row where D is present.
Simple:
- Index the first row
- search that row for your string
- use the found index to index the column from your data
Like this:
This shows the basic principle, but does not include any error checking (like for "not found" conditions)…
Btw. didn't I suggest to use AutoCleanup before uploading your VI?
you didn't upload VI Gerd..
01-23-2019 03:12 AM - edited 01-23-2019 03:13 AM
Hi sam,
you didn't upload VI Gerd..
No, intentionally.
Come on: you see my example!
It's just 3 functions, two of them IndexArray and one Search1DArray. And you got an explanation, so you should be able to replicate the example on your own!
(By wiring yourself you learn much better than by just taking code from someone else. :D)
01-23-2019 03:21 AM
@GerdW wrote:
Hi sam,
you didn't upload VI Gerd..
No, intentionally.
Come on: you see my example!
It's just 3 functions, two of them IndexArray and one Search1DArray. And you got an explanation, so you should be able to replicate the example on your own!
(By wiring yourself you learn much better than by just taking code from someone else. :D)
hahhahaha yes got it man btw thanks allot. see you in next problem 🙂