Forum Discussion
EXCEL AND big data
How do i use Excel to analyse data. I have approx 3000 rows of data to be compared to approx 1.6 million row of data and extract data baaed on a certain column.
Thanks Wyn. As i mentioned it to Van, I wanted to add an extra columns to help create a unique ID. But everytime i try to put formula using a custom column, my excel crashes.
I am using the latest version of excel and my laptop is also pretty new. Is it a hardware constraints ?
I am using the latest version of excel and my laptop is also pretty new. Is it a hardware constraints ?
Perhaps I missed something, I understood initial tasks as filter one table based on values in another table column. Or okay, take values only from one or few columns of the first table, doesn't matter.
If so, why do you need any formulas and even relationships? Perhaps you may forget for a while about the size of the source and provide small sample which illustrates what shall be done.
So far I see that as DAX expression
evaluate
FILTER(Table1,
Table1[A] IN VALUES (Table2[A])
)