Hi Abhi anvi. I have mailed you. can you please provide me DXL training notes & videos. so i can learn .
@swapnagotike39212 күн бұрын
Sir - for Salary question where should we find answer . If LCA salary is different than offer letter salary what should I mentioned. Please answer my question ASAP. My friend will get interview next week
@raffymcfee984612 күн бұрын
Thank you so much for this nonsense problem thank you! You really helped me
@pragatimishra-b4f14 күн бұрын
hey u saved my day... thanks
@NarenderReddy-q8n23 күн бұрын
thank you
@Entertainment-nk8to24 күн бұрын
on esmall correction Scribe is mamdatory in all review process except informal review
@tengkuaidatul939326 күн бұрын
concise and straight to the point, thanks!
@abhianvitutorials353Ай бұрын
import time from pywinauto import Desktop from pywinauto import Application import pyautogui def change_display_settings(size=None, resolution=None, orientation=None): pyautogui.press("win") time.sleep(1) pyautogui.typewrite("settings") time.sleep(3) pyautogui.press("enter") time.sleep(2) pyautogui.typewrite("change the resolution of the display") time.sleep(2) # pyautogui.click() # time.sleep(1) pyautogui.press("enter") time.sleep(1) pyautogui.press("enter") time.sleep(1) main_window = Desktop(backend="uia").window(title="Settings") # Setting resolution if main_window.ComboBox2.selected_text().find(resolution) != -1: pass else: for i in range(0, 10): time.sleep(2) main_window.ComboBox2.type_keys("%{DOWN}") time.sleep(1) try: main_window.ComboBox2.select(i) time.sleep(1) except Exception: pass time.sleep(2) pyautogui.hotkey('tab') time.sleep(1) pyautogui.press("enter") if main_window.ComboBox2.selected_text().find(resolution) != -1: break # Setting size if main_window.ComboBox1.selected_text().find(size) != -1: pass else: for i in range(0, 10): main_window.ComboBox1.type_keys("%{DOWN}") try: main_window.ComboBox1.select(i) time.sleep(2) except Exception: pass if main_window.ComboBox1.selected_text().find(size) != -1: break # Setting orientation if main_window.ComboBox3.selected_text().find(orientation) != -1: pass else: for i in range(0, 10): time.sleep(2) main_window.ComboBox3.type_keys("%{DOWN}") try: main_window.ComboBox3.select(i) time.sleep(2) except Exception: pass time.sleep(2) pyautogui.hotkey('tab') time.sleep(1) pyautogui.press("enter") if main_window.ComboBox3.selected_text().find(orientation) != -1: break change_display_settings("100", "1400", "Landscape")
@bharathsanthosh1373Ай бұрын
🫂tnku
@SloppyNinja777Ай бұрын
What if I want to remove values that are blank/null?
@HanhLe-ju6bsАй бұрын
I tried to apply same but it did not work for my data
@ibrahimm695Ай бұрын
Great Sir
@pratikbirari95082 ай бұрын
how to hide those are in bold but want to see rest others. Like want to hide 36,004.12 and show the values you hide in this video
Table.TransformColumns (#"Added Custom", { {"Custom", each if Number.IsNaN (_) then null else _, type number}})
@jayeshpercy92653 ай бұрын
worst!
@user-lm5wb8vi1x3 ай бұрын
Finished watching
@DmitriyGonchar3 ай бұрын
thanks a lot, you saved my day!
@subhakarpatnala48073 ай бұрын
I am listening that Delhi, Mumbai and Kolkata consulates closed for h1b interviews. We can schedule h1b interview only for hyderabad or chennai. Is this true?
@RichardOliver4 ай бұрын
What are you adding? Text suddenly appears. This needs to be better explained, in my opinion.
@morganerickson4394 ай бұрын
Thank you, thank you, THANK YOU!!
@jadegirlification4 ай бұрын
Thanks for sharing. How about if a Name Column contains some duplicate values in each cell. Not all the cells have duplicate. E.g Cell 1: "JOHN A SMITH JOHN A SMITH JOHN A SMITH" Cell 2: "MARK TOM MARK TOM" Cell 3: "MARY RUTH JONES MARY RUTH JONES How can I split the column to only show: Cell 1: JOHN A SMITH, Cell 2: MARK TOM, Cell 3: MARY RUTH JONES? Thanks so much for your assistance.
@abhianvitutorials3534 ай бұрын
My code works if names are separated by a comma. In your case, need to think a new logic
@jadegirlification4 ай бұрын
@@abhianvitutorials353Ok. Thanks so much
@abhianvitutorials3534 ай бұрын
In PQ go to menu Add column > custom column and past below function, replace column1 with the name of your column: Text.Combine(List.Distinct(Text.Split([Column1]," "))," ")
@sumitkumar899094 ай бұрын
where is solution ??
@mahiemaheswari55364 ай бұрын
Still not working
@SairamV175 ай бұрын
I need to give the diff color code to column …. Is it possible?
@gowthamipm23505 ай бұрын
Hi sir, Good morning This is gowthami I have one question related to hide a column (measure ) from table visualization . That column I have used for sorting purpose I dnt want to showcase to users in table visualization and also after extraction also Plaese can you help me on that,it's very urgent requirement Thanks Gowthami
I heard hyd consulate is issuing 221g for most of the people, any reason for that?
@praveenvilla21345 ай бұрын
Me too get same information about this
@AkhandaVihari5 ай бұрын
@@praveenvilla2134 any particular reason?
@suresha62105 ай бұрын
Without knowing LCA how you attended interview Abhi thats basic document bro
@TwoLegendsandaPodcast-fz9gg5 ай бұрын
@5:19 you say -100 belongs in second category, but ">-100 and < 100" does not include -100, since >-100 starts at -99, then -98...never hitting -100, right?
@abhianvitutorials3535 ай бұрын
You are correct. -100 belongs to first class <= -100
Hi Abhi, could you please let me know if you have any idea about recent H1B interviews in Hyderabad? If so, could you please share the experiences? I've heard that many candidates are receiving 221G.Do you have any idea why we are not getting appointments for OFC and the consulate in Mumbai and Delhi?
@sunilsachdeva6205 ай бұрын
Hi @himeshkashyap..what is the source of the information you mentioned many candidates are getting 221G?
@KanalGorski5 ай бұрын
Hello, you helped me today. Thank you.
@abhishekpadhi61845 ай бұрын
Thank you so much :) Very well explained and nice selection of questions set.
@ckkim53735 ай бұрын
*Promo SM*
@sudhanshuvishodia5 ай бұрын
Thanks buddy ! Been struggling with this from last couple of days, now I know why it was not working for me. :)
@abhianvitutorials3535 ай бұрын
Glad I could help
@feifeixing5 ай бұрын
How to hide the subtotal for that column then?
@abhianvitutorials3535 ай бұрын
Go to format button and switch off column sub totals
@BK_silent_eyes5 ай бұрын
Great video, But Sir is it possible to replace the value of a specific column of a single row if other rows have same value as the column I wanted to modify on a row?
@abhianvitutorials3535 ай бұрын
Yes. Absolutely. Because index is different for each row, you can delete specific row, eventhough other rows having same column value.
@BK_silent_eyes4 ай бұрын
@@abhianvitutorials353 Thank you
@vgriga96825 ай бұрын
Short and to the point! Thank you so much. You made my day!