I have a datatable with multiple columns. I want only one column from it conditionally. Help

[hacky (NotHacker)]

Hi Team,

So I have a datatable as below:- (dtInput)

I need to get the Sub-Datatable from the above datatable such that the Month name shall be referred and corrospoding range is gotten in the sub-datatable.

NOTE:- I have handled the variables, just need logic or idea to extract conditional Range.
Input variables
1.:- dtInput
2.:- InputMonth

For eg:
1.:- dtInput is as shown in abve dt
2.:- InputMonth is “18-Jul”
then output sub-datatable contains below:-

For eg:-
1.:- dtInput is as shown in abve dt
2.:- InputMonth is “19-Mar”
then output sub-datatable contains below:-

Hope the examples made it clear.

Note:- I do have multiple approaches but wanted a most efficient one.

Thanks and Regards,
@hacky

[AshwinS2 (Ashwin S)]

Hi @hacky

Use newdt=dt.select(“Datetime.parsexact(datetime.now.tostring,“dd-mmm-yyyy”, System.globalization.cultureinfo.invariantculture)”). copy todatatable ()

[hacky (NotHacker)]

@AshwinS2
Please note that I already have a variable having the InputMonth, so need to fit that variable to fit into your code.

Also the new variable “dtNew” needs to have the outputted value as shown in my question.

Please help me such that my varibles shall be used in your logic/

Also when I do that from my side it shows some error saying that end of expression was missing.

[hacky (NotHacker)]

@HareeshMR
@Palaniyappan

Plz help

[Palaniyappan (Forum Leader)]

@hacky

“19-Mar”

Fine
one small clarification if we mention as “19-Mar” is it taking as header of the column in the datatable
Cheers @hacky

[hacky (NotHacker)]

@Palaniyappan, I have created a DTinput such that “19-Mar”, “18-Apr” act as a headers

[Palaniyappan (Forum Leader)]

Fine
then we can get like this directly
Finaldt = outdt.DefaultView.ToTable(False,“yourcolumnnameasstring”)

where Finaldt is a datatable variable
Cheers @hacky